How to find Column Name Using COL_NAME() Function?

Question

Sushant Mishra · Answer

SELECT COL_NAME(object_id('Sample..SignIn'),2) AS col_nameand 
and 
It takes two parameter table
id and ordinal position and column name
Also you can use
SELECTand and and  name AS col_name FROM sys.columnsWHEREand and and  object_id=object_id('Sample..SignIN') AND column_id=2
output

interview

How to find Column Name Using COL_NAME() Function?

Sushant Mishra

Can you answer this question?

1 Answers

Liked By